Get Transaction Details [TransactionDetail]

TransactionDetail

Get Transaction Detail

This interface is used to get the details of the specified transaction. Currently, only five types of transaction queries are supported, including adding, modifying, deleting, truncating, and merging table data. The permissions of adding table, modifying table, truncating table, deleting table, and merging table data are still used.

Request address

GET/POST
http://OmsAddress/app/newoms.php/webservice/oamp/transaction/detail/<set_id>/<trans_id>?cmd=cmdVal&ip-type=webservicerest&access-token=AccessTokenVal

GET parameter description in url

POST request parameter description

Data Parameters

Use json format to represent the record related information. The following is an example:

{
    "get_action": 0
}

Return Syntax

Return Parameter Description

1. When the returned status code is not 200, it indicates that the query was unsuccessful, and the returned data is error message

2. When the returned status code is 200, it indicates that the transaction details are got successfully

Description of transaction fields

Description of each field of the transaction’s action

The transaction status list and the status transformation that can be realized by using the web service interface

Request Example

Send A Request through the Curl Method

For the parameters in the command, please refer to the “Description of POST Request Parameters” on this page. For the method to obtain access-token, see: Get access-token

curl -H “Content-type: application/json” -X “GET” -d ’{
    “get_action”: 0
}’ http://omsaddress/app/newoms.php/webservice/oamp/transaction/detail/%3Cset\_id%3E/%3Ctrans\_id%3E?cmd=cmdVal&ip-type=webservicerest&access-token=\\&set\_id=\\&trans\_id=\\

Return Example

Successful Return Example

Status of http request = 200

1. An example of successfully getting the details of a table-adding transaction

{
    "Id": 300,
    "AppId": 2,
    "ZoneId": 5,
    "Type": 283,
    "Status": 9,
    "Reason": 0,
    "Num": 0,
    "IdName": "add_table350",
    "Data": "proxy@;tcapsvr@master#1",
    "Memo": "AddTableManual",
    "CreateUser": "tcaplus",
    "CreateTime": "2021-07-23 16:17:20",
    "UpdateTime": "2021-07-23 16:17:47",
    "CanRedo": 1,
    "CanSuspend": 1,
    "CanRollback": 1,
    "SetId": 1,
    "ExtendInfo": "",
    "MaxConcurrentCount": 10,
    "StatusText": "Successfully completed"
}

1. An example of successfully getting the details of a table-modifying transaction

{
    "Id": 405,
    "AppId": 2,
    "ZoneId": 3,
    "Type": 281,
    "Status": 10,
    "CanRedo": 1,
    "CanSuspend": 1,
    "CanRol lback": 1,
    "Reason": 2,
    "Num": 0,
    "IdName": "test_table_generic_modify",
    "Data": "fc448894b1fc2e22ece9a6873b33c7b6",
    "Memo": "ModifyTable",
    "CreateUser": "tcaplus",
    "CreateTime": "2017-03-02 21:38:30",
    "UpdateTime": "2017-03-02 21:41:37",
    "SetId": 126,
    "ExtendInfo": "",
    "MaxConcurrentCount": 10
}

1. An example of successfully getting the details of a table-truncating transaction

{
    "Id": 408,
    "AppId": 2,
    "ZoneId": 3,
    "Type": 279,
    "Status": 9,
    "CanRedo": 1,
    "CanSuspend": 1,
    "CanRollback": 1,
    "Reason": 0,
    "Num": 0,
    "IdName": "test_table_generic_modify",
    "Data": "",
    "Memo": "TruncateTable",
    "CreateUser": "tcaplus",
    "CreateTime": "2017-03-02 21:57:56",
    "UpdateTime": "2017-03-02 22:00:29",
    "SetId": 126,
    "ExtendInfo": "",
    "MaxConcurrentCount": 10
}

1. An example of successfully getting the details of a table-deleting transaction

{
    "Id": 411,
    "AppId": 2,
    "ZoneId": 3,
    "Type": 363,
    "Status": 9,
    "CanRedo": 1,
    "CanSuspend": 1,
    "CanRollback": 1,
    "Reason": 0,
    "Num": 0,
    "IdName": "test_table_generic_modify",
    "Data": "",
    "Memo": "DeleteTable",
    "CreateUser": "tcaplus",
    "CreateTime": "2017-03-02 22:12:49",
    "UpdateTime": "2017-03-02 22:17:38",
    "SetId": 126,
    "ExtendInfo": "",
    "MaxConcurrentCount": 10
}

Failed Return Example

Status of http request != 200

{
    "name": "Unauthorized",
    "message": "You are requesting with an invalid credential.",
    "code": 0,
    "status": 401,
    "type": "yii\\web UnauthorizedHttpException"
}

{
    "trans_id": [
        "for the cmd(cmd:10004),can only get those transaction of which type is in 279,type of transaction(id:411) is 363"
    ]
}